enq: TS - contention
Enqueue wait. Temporary Segment (also TableSpace)
Additional Information
An enqueue is a wait for a resource held by another.
enq: TS - contention has been seen when temporary tablespaces are being dropped.
How to reduce this wait
Ensure no sessions are using temporary segments in the tablespace you are trying to drop. Donghau’s blog has SQL to allow identification of temporary segments users.
SELECT se.username username, se.SID sid, se.serial# serial#, se.status status, se.sql_hash_value, se.prev_hash_value,se.machine machine, su.TABLESPACE tablespace,su.segtype, su.CONTENTS CONTENTS FROM v$session se, v$sort_usage su WHERE se.saddr=su.session_addr;
Additional Links
Oracle Docs - Oracle Enqueue Names
Donghua's Blog - Drop temporary tablespace hang with "enq: TS - contention"
Search online
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.